|
Courses >
Computer Applications > Introduction to Microsoft Access 2003 (PLU-prior approval form required)
 Learn how to use Microsoft's powerful and award-winning database to store, locate, and print just about any type of important information. In this six-week online workshop, you'll learn how to create tables, relationships, custom data entry forms, queries, reports, mailing labels, and macros. You'll also learn how to merge the data in your Access tables with Microsoft Word form letters.
This course includes a knowledgeable and caring instructor who will guide you through your lessons, facilitate discussions, and answer your questions. The instructor for this course will be Craig Power.
 Craig Power has worked in adult continuing education for more than 18 years. A UCLA graduate, he created custom accounting software for state and local governments; developed an online course delivery and marketing platform currently used by more than 1,500 colleges and universities in the US, Canada, and Australia; developed an interactive cellular biology video for the Los Angeles Unified School District; taught college-level information technology courses; started and grew a thriving small business; and served as an executive with a large academic publishing corporation.
To purchase this course, click the Enroll Now button below:
Requirements:
Microsoft Windows XP or 2000, Microsoft Access 2003 or Microsoft Office Professional Edition 2003 (please be sure to install this software on your computer before the course begins), Internet access, e-mail, and the Microsoft Internet Explorer or Mozilla Firefox Web browser.
Note: Microsoft Word 2003 or Microsoft Office Professional Edition 2003 will also be required for Lesson 12.
This course is not suitable for Macintosh users, nor for users of any of the 2007 versions of MIcrosoft Access.
Syllabus:
All courses run for six weeks, with a two-week grace period at the end. Two lessons are released each week for the six-week duration of the course. You do not have to be present when the lesson is released, but you must complete each lesson within two weeks of its release.
A new section of each course starts on the second or third Wednesday of each month. If enrolling in a series of two or more courses, please be sure to space the start date for each course at least two months apart.
| Week One |
| Wednesday - Lesson 01 |
Creating a Table: the Basics
|
| Friday - Lesson 02 |
Creating Tables: Customizing Fields
|
| Week Two |
| Wednesday - Lesson 03 |
Creating Relationships Between Tables
|
| Friday - Lesson 04 |
Creating Custom Data Entry Forms: Part 1
|
| Week Three |
| Wednesday - Lesson 05 |
Creating Custom Data Entry Forms: Part 2
|
| Friday - Lesson 06 |
Adding Controls to a Data Entry Form
|
| Week Four |
| Wednesday - Lesson 07 |
Performing Queries on Your Tables
|
| Friday - Lesson 08 |
Creating Basic Reports
|
| Week Five |
| Wednesday - Lesson 09 |
Advanced Reporting Techniques
|
| Friday - Lesson 10 |
Super Advanced Reporting Techniques
|
| Week Six |
| Wednesday - Lesson 11 |
Automating Access with Macros
|
| Friday - Lesson 12 |
Exporting Access Tables to Word
|
To purchase this course, click the Enroll Now button below:
Student Reviews:
"I found the material easy to follow and thought the content contained pertinent information to begin working with Access databases. In the discussion area, I was able to find a resolution to an issue I ran across. I plan to continue taking more advanced classes as time permits. Thank you for the opportunity to make my job easier!"
"I loved the course! I feel that I now understand the basics of Access, which is what I wanted to get out of the course."
"I really enjoyed the class and interacting with everyone online. It was one of the "easier" classes I've taken! The instructor was awesome and was very helpful in getting us through the lessons by using humor and simplicity for everyone to understand."
"Thank you, I enjoyed taking the course online. It allowed me to work when I had the time. The instructor has a friendly style and was easy to work with. I will take other courses from him and recommend him to others."
"This class was essential in helping me maintain our new Access Data Base for New Student Orientation. I have learned so much. Our office is functioning more efficiently as a result of this course. Thank you!"
"This course came to me highly recommended. Now I know why. Thank you for the opportunity."
"This is the first time I have taken an online course, and it turned out to be a very enjoyable experience. I liked the fact I could progress at my own pace, and that it elminated the traditional classroom problem of repeatly getting off the subject. That can be particularly confusing when you are trying to learn a new software program! Thank you for a great experince!"
"This is the first time I have taken an on-line course and I was very pleased. I feel as though I have learned enough to at least start working with Accsess. I felt the instructor was very thorough and appreciated his sense of humor. In other words, the class was interesting and helpful, not dry."
"This was an excellent introduction to many of the powerful features in Access. I feel more than equipped to work with basic databases and greatly intrigued to learn more."
To purchase this course, click the Enroll Now button below:
Recommended Courses:
Students who enrolled in Introduction to Microsoft Access 2003 (PLU-prior approval form required) were also interested in the following courses:
Introduction to Microsoft Access 2007
Introduction to Database Development
Introduction to Microsoft Excel 2003
Intermediate Microsoft Access 2003
Introduction to SQL
|
